___________________________________

CREATE TABLE Shipper
(
ShipperID CHAR(2) NOT NULL,
CompanyName CHAR(20),
Phone CHAR(15)
);





____________________________________

CREATE TABLE Employee
(
Emp_ID CHAR(3),
Emp_Fname CHAR(10) NOT NULL,
Emp_Lname CHAR(12) NOT NULL,
Emp_Password CHAR(8) NOT NULL,
Emp_email CHAR(15)

);

 ALTER TABLE Employee
 ADD CONSTRAINT PK_employee_Emp_ID  PRIMARY KEY (Emp_ID);







_______________________________________
Create TABLE Customer
(
Cust_ID CHAR(5) NOT NULL,
Cust_Fname CHAR(10) NOT NULL,
Cust_Lname CHAR(12) NOT NULL,
Cust_Password CHAR(8) NOT NULL,
Cust_email CHAR(15),
Cust_address CHAR(30),
Cust_city CHAR(12),
Cust_state CHAR(2),
Cust_zip CHAR(9),
Locked_flag CHAR(1),
Emp_ID CHAR(3)
);
ALTER TABLE Customer
Add constraint PK_customer_Cust_id primary key (Cust_ID);
ALTER TABLE Customer
Add constraint FK_Customer_Emp_ID foreign key (Emp_ID) references Employee (Emp_ID);